﻿<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="Table" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
  
  <alias>
    <typeAlias alias="Table" type="Lyh.Dbdg.Model.Table"/>
  </alias>
  
  <resultMaps>
    <resultMap id="TableResult" class="Table">
      <result property="Name" column="Name"/>
      <result property="Description" column="Description"/>
    </resultMap>
  </resultMaps>
  
  <cacheModels>
    <cacheModel id="TableCache" implementation="LRU">
      <flushInterval hours="24"/>
      <property name="CacheSize" value="1000"/>
    </cacheModel>
  </cacheModels>
  
  <statements>
    <select id="GetList" resultMap="TableResult" cacheModel="TableCache">
      SELECT TABLE_NAME Name, TABLE_COMMENT Description
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = DATABASE()
    </select>
  </statements>
  
</sqlMap>